Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fungoid” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fungoid124525(None) 
fungoids1343991fungoids
fucoid1237892fu_coid
fulgid1137042fulg_id
fungi95014132fung_i_
fungic12387812fung_ic
fungo94413132fungo__
fungoes11388812fungoes
fungous11367432fungous
algoid83011473_algoid
buncoed12378443buncoed
bunged105218793bung_ed
bungled114112243bungled
bunkoed14356663bunkoed
conoid9818883con_oid
cuboid1139503cu_boid
dentoid9310663dentoid
dunged95414693dung_ed
euploid1038963euploid
factoid1338693factoid
fanfold1485373fanfold
fanged114318223fang_ed
fantod102010033fanto_d
fibroid1337243fibroid
frigid1136923frig_id
fucoids1335663fu_coids
fudged125212823fudg_ed
fugged124615383fu_gged
fugio9310923fu_g_io
fugios1037583fu_gios
fugled114813693fu_gled
fugued11478713fu_gued
fund85624983fun___d
funded114413893fun_ded
fundi96814913fun_di_
fundic12389083fun_dic
funfair1342033funfair
fungal10388733fung_al
fungals11276783fungals
fungicide1642553fungicide
fungus10418183fung_us
funked144214113fun_ked
funkia1336343fun_kia
funned103613953fun_ned
ganoid8314443gan_oid
jungled16349643jungled
languid936623languid
lentoid8310683lentoid
lunged85418273lung_ed
lungi65516053lung_i_
lungis77113023lung_is
lungyi10525093lungyi_
lungyis11294103lungyis
mangold1137213mangold
mucoid1139783mu_coid
mungo84916053mungo__
mungoes103510463mungoes
mungos94311373mungo_s
pinguid1146243pinguid
pongid104111583pong_id
pungled114210083pungled
quinoid1737353quinoid
tangoed9318833tangoed
turgid868013turg_id
unbid83214643_un_bid
uncoil8811853_uncoil
undid72415363_un_did
unfold10179703_unfold
unfond10149113_unfond
ungird887973_ungird
ungot61718063_ungo_t
unguis738453_unguis
unhood1039233_unhood
unlaid7311753_unlaid
unload73010803_unload
unmold9148313_unmold
unpaid939473_unpaid
unsaid7411833_unsaid
unsold71410513_unsold
unsolid8138373_unsolid
untold7149683_untold
valgoid1255213valgoid
zincoid1946663zincoid
zygoid2045943_zygoid

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit134027845.80023108.1
3Display Results84840.0136461.5
 (SQL Overall)178691846.21628746.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.