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 “orgiast” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
orgiast83746(None) 
orgiasts943801orgiasts
orbiest9312412orbiest
orgasm966302org_asm
orgeat7515032orgea_t
orgeats838352orgeats
orgiac934992orgia_c
orgiastic1243692orgiastic
orgies72316092orgies_
aghast105711373_aghast
agist66325583_agi_st
agrias74315393agrias_
aorist64827873aor_i_st
argils75213623argils_
arginase946433arginase
arias55438023ar_ias_
artiest73121993artiest
artist64125543arti_st
boggiest123110933boggiest
breast8319633br_east
cagiest102916433cagiest
corgis9314413corgi_s_
corkiest143114793corkiest
corniest102117303corniest
dodgiest11308713dodgiest
doggiest113410523doggiest
dorkiest133111253dorkiest
driest74722753dr_iest
edgiest92310353edgiest
foggiest13249653foggiest
forecast1349763forecast
foremast1348613foremast
forepast1348043forepast
forgat104018583forg_a_t
forkiest153812303forkiest
gast56052563__g_ast
ghast95621223__ghast
giant65430593__giant
gist56046763__gi_st
goriest82218743gor_iest
gorsiest92511133gorsiest
grist65529873gr_i_st
heliast10312073heliast
horniest112814043horniest
hornist102314823horni_st
horsiest112513263horsiest
legist71315253legi_st
loggias9356783loggias_
loggiest103011013loggiest
logiest82515543logiest
norias65518203nor_ias_
oakiest112913923oakiest
oast47156323o___ast
obias76116863o_bias_
oblast8613663o_blast
oboist8312683oboi_st
odist6421913o_di_st
offcast1544473offcast
ogrish1039263ogri_sh
ogrism937913ogri_sm
ohias84415573o_hias_
oiliest72817683oiliest
ologist8313833ologi_st
ooziest163411523ooziest
oralist7619633oralist
orangiest1038463orangiest
orbit73622063orbi__t
orbits84211443orbits_
orcas75918623or_cas_
orcins83313433orcins_
organ6915393org_a_n
organa789213org_ana
organist9411543organist
organs7912913org_ans
orgasms1054293org_asms
orgastic11116213org_astic
orgic8311823orgi__c
orient6322533or_ient
origami1045453origami
origan7310693origa_n
origans839973origans
origins8310463origins_
ornis54616773orni_s_
orpins83614163orpins_
orris54516553orri_s_
outcast91013743outcast
outfast101412123outfast
outlast71015443outlast
podgiest12269093podgiest
porgies103017003porgies_
porkiest143513713porkiest
porniest103214313porniest
precast11314853precast
priest84125423pr_iest
raias54631123_raias_
recast83422773_recast
repast83520633_repast
riant55833153_r_iant
rias45540593_r_ias_
roast56230143_r_oast
ropiest93317773ropiest
rosiest73919213rosiest
sagiest82617983sagiest
soggiest102711643soggiest
sorriest8413883sorriest
urbias839093urbias_
vigias104110893vigias_
wordiest122311543wordiest
wormiest13249543wormiest
wriest94419713wr_iest
wrist84827563wr_i_st

Search took 8 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.406440125.6
2DLD Change Limit1340271117.12618808.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.57823580.2
 
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.