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

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

117 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
cruet7483184(None) 
cruel74815901cruel
cruets85314951cruets
cruset84425091cruset
crust75827661crust
curet75447641curet
armet76739452armet
bluet75631192bluet
bruit76126722bruit
brunet84419292brunet
brunt75728752brunt
brut66537962bru_t
brute75321782brute
buret77444012buret
cadet85339332cadet
caret75360562caret
carnet84732872carnet
carpet104530092carpet
cermet10321152cermet
chute104316462chute
civet105828732civet
clue65324532clue_
clued84917682clued
clues74623032clues
comet95946072comet
coquet174318012coquet
cornet84436732cornet
corset85636222corset
corvet114626932corvet
coset75748842coset
count74932052count
court75532762court
covet105638942covet
craft105327662craft
crate76537402crate
cred76530882cr_ed
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
crept95125892crept
crest74632692crest
crew96122672cr_ew
cried84624282cried
crier74724462crier
cries75438402cries
crit65743712cr_it
croft105622682croft
croquet1859682croquet
croute84617272croute
cru57129562cru__
cruces105117542cruces
cruck135615322cruck
crud75219612cru_d
crude86018572crude
cruder95612382cruder
crudes96218622crudes
crudest104510332crudest
cruds85815852cruds
cruelty1234112cruelty
crumb114313592crumb
crump115616422crump
crumpet133711062crumpet
cruor7310442cruor
crura7312582crura
crus65828482cru_s
cruse75726102cruse
cruses88127712cruses
crusets93811042crusets
crush106815992crush
crusts84916542crusts
crusty114911342crusty
crux135415002cru_x
cruxes154911562cruxes
crypt123715232crypt
cue57544182c_ue_
cued76329562c_ued
cues65438982c_ues
culet76040342culet
cult66541152c_ult
cunt66243672c_unt
cure66149122cure_
cured85932132cured
curer75030752curer
cures75645432cures
curets84922342curets
curst74931022curst
curt67051712c_urt
curvet114720242curvet
cut57957662c_u_t
cute66440452c_ute
duet56446262_duet
eruct74022352eruct
erupt74220062erupt
fret75845042fr_et
fruit85122222fruit
greet65835322greet
grue55825712grue_
gruel66014742gruel
grues65721962grues
grunt65523542grunt
ret35982832_r_et
rue35549262_rue_
rued55729792_rued
ruer46127562_ruer
rues46044482_rues
runt46647982_runt
rust45544912_rust
rut35560522_ru_t
suet46754822_suet
tret46653532tr_et
true46725852true_
trued65117692trued
truer54916642truer
trues54925322trues
truest64816192truest
trust55426852trust

Search took 4 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 Filter178691538000.1731032896.0
2DLD Change Limit538001172.78019352.5
3Display Results1171170.0333545.5
 (SQL Overall)1786911172.98659842.9
 
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.