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

104 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
squeaker218488(None) 
squeaked2283901squeaked
squeakers2284111squeakers
squeakier2242901squeakier
squealer17115601squealer
quaker193811622_qu_aker
sneaker112910452s_neaker
speaker133311212s_peaker
squarer163410652squ_arer
squawker2443092squawker
squeak1935252squeak__
squeaks2034522squeak_s
squeaky2343072squeak_y
squealed1885352squealed
squealers1894452squealers
squeezer2643372squeezer
streaker12229472streaker
beaker125520693__beaker
bleaker133510533_bleaker
breaker133912923_breaker
leaker104620073__leaker
phreaker1735053phreaker
quake184114643_qu_ake_
quaked203910033_qu_aked
quakers20309683_qu_akers
quakes194013343_qu_akes
quakier20239203_qu_akier
quaver18309313_qu_aver
queasier1734473_queasier
queazier2642833_queazier
queer143712813_que__er
queerer16106503_queerer
queller16289293_queller
querier16310013_querier
quester161410023_quester
queuer15357253_que_uer
quicker2247023_quicker
saker95132023s___aker
screaked15246973screaked
screamer12267873screamer
sculker13318323scu_lker
sealer63928963s__ealer
seamer84223613s__eamer
searer65432023s__earer
seater64534153s__eater
seeker103615363s__eeker
sequencer2044573sequencer
sequester1844443sequester
shaker134319463s__haker
shearer104414683s_hearer
shoemaker1843843shoemaker
shucker163710103shu_cker
skulker10325683sku_lker
slaker104219273s__laker
sleeker11339823s_leeker
smearer94110403s_mearer
sneaked12329693s_neaked
sneakers12308643s_neakers
sneakier1245143s_neakier
soaker105717533s__oaker
speakers14299453s_peakers
spearer93913663s_pearer
spreader1137473spreader
squaller1736083squaller
squalor1644423squ_alor
squander1835533squander
square154513353squ_are_
squared173610553squ_ared
squarers17338003squ_arers
squares163714453squ_ares
squasher20185773squasher
squatter1735913squatter
squawked2543013squawked
squawkers2542483squawkers
squeakiest2342773squeakiest
squeakily2541993squeakily
squeaking2334213squeaking
squeal1538013squea__l
squeals1636503squea_ls
squeegee1843683squeegee
squeeze2543593squeeze_
squeezed2743253squeezed
squeezers2742553squeezers
squeezes2643823squeezes
squegged2042893squegged
squelcher2342783squelcher
squinter1747353squinter
squirmer1934363squirmer
squirter1746513squirter
stealer72913973s_tealer
steamer93313093s_teamer
streaked13228453streaked
streakers13218123streakers
streakier1334843streakier
streamer10239503streamer
streeker12206633streeker
suaver93014233s_u_aver
sucker124120663s_u_cker
sugarer837323s_ugarer
sulker104015923s_u_lker
swearer10349953s_wearer
sweater103712723s_weater
weaker134015443__weaker
wreaker143610043_wreaker

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 Filter1786911461620.310576422.6
2DLD Change Limit1461621048.80016609.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911049.15619516.3
 
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.