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 “choragi” 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.

98 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
choragi134668(None) 
choragic1646061choragic
choregi1344561choregi
choragus1474292choragus
choral115118492chora_l
chorale124313352chorale
chorals124614102chorals
corgi8316082c_or_gi
anchorage1544413anchorage
borage93917013_borage
chai95929903ch__a_i
chapati14118003chapati
characid1646843characid
characin1547973characin
charade13129903charade
charas114223593chara_s
charge125114213char_ge
charpai1436623charpai
charqui2143993charqui
chiral114614413chira_l
chivari1536033chivari
chloral12169983chlora_l
chlorals13148023chlorals
chlorate133112693chlorate
choana1138443cho_ana
chola104718033chola__
cholas114817993chola_s
cholate122114933cholate
chorales133712873chorales
chorally1638103chorally
chord115917263chor__d
chordal13449883chordal
chordate1448033chordate
chorded144710553chorded
chords125214633chor_ds
chore105126763chor__e
chorea115216083chor_ea
choreal124412223choreal
choreas124414203choreas
choreatic1647713choreatic
chored125321883chor_ed
choregus1484213choregus
choreic1438693choreic
choreoid1447923choreoid
chores114828023chor_es
chorial124214143chorial
choriamb1744153choriamb
choric133515893chor_ic
chorine123218363chorine
choring133617663choring
chorioid1448323chorioid
chorion12311763chorion
chorizo2136313chorizo
choroid13311793choroid
chorten122811303chorten
chortle124210443chortle
chorus115014763chor_us
chough15699243cho_ugh
coati75624633c_o_ati
coral76033453c_ora_l
corals85325143c_orals
cordage11310063c_ordage
corgis9314403c_or_gis
corkage1438373c_orkage
corsage1039803c_orsage
courage10310993courage
cowage12310663c_owage
crag75625303c__rag_
crags85622573c__rags
curagh1236553c_uragh
curari84414403c_urari
curragh1344293curragh
forage104616993_forage
hoagie102310003_ho_agie
hoagy124710473_ho_agy
homage121210603_homage
hongi96715853_ho_ngi
hora76136553_hora__
horah117922043_hora_h
horahs126313873_horahs
horal86328673_hora_l
horary12310383_horary
horas86333093_hora_s
korai97018513_kora_i
moorage1038733moorage
oorali6311263_oorali
phorate12413363phorate
ragi56032283___ragi
shogi95013993sho__gi
shoran94016033shora_n
shorans102812403shorans
shortage1236303shortage
storage8310473storage
thoracic1546383thoracic
thorax1638253thora_x
tragi64717173__tragi
woorali1045263woorali
woorari1044633woorari

Search took 10 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.1731032896.0
2DLD Change Limit134027988.86015127.2
3Display Results98980.0761289.5
 (SQL Overall)178691989.10919617.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.