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

110 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
cruces10511754(None) 
crucks144412581crucks
crudes96218621crudes
cruses88127711cruses
cruxes154911561cruxes
truces84916331truces
braces108427772braces
brumes106417072brumes
brutes86118682brutes
bruxes154811022bruxes
calces104420052calces
carices114220952carices
caucus1039602caucus
caules85927252caules
causes88026472causes
ceruses93716232ceruses
chucks174812932chucks
chutes114615762chutes
clucks144512072clucks
clues74623032clu_es
couches144020462couches
coupes105022522coupes
cracks144817002cracks
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crases85532312crases
crates85736052crates
craves115825392craves
crazes174720132crazes
creches14313092creches
cremes104517992cremes
crepes105419342crepes
cricks144316052cricks
cries75438402cr_ies
crimes105521582crimes
cripes105120872cripes
crises84529432crises
crocks145118422crocks
crocs95722432croc_s
crocus104813172crocus
crones84729242crones
crores86121162crores
crouches153711282crouches
croupes114613102croupes
croutes94815642croutes
crozes174417662crozes
cruck135615322cruc_k
crude86018572crude_
cruder95612382cruder
crudest104510332crudest
cruds85815852cru_ds
cruel74815902cru_el
cruet74831842cru_et
cruets85314952cruets
cruise84314042cruise
cruises93514442cruises
crumbs12409232crumbs
crumps124514342crumps
crunches153711352crunches
cruors838622cruors
crus65828482cru__s
cruse75726102cruse_
cruset84425092cruset
crusets93811042crusets
crushes124215132crushes
crusts84916542crusts
crutches15359582crutches
cubes95028162c_ubes
cues65438982c_u_es
cukes115422092c_ukes
curches143512742curches
cures75645432c_ures
curies84934022curies
curses85328272curses
curves114619282curves
cutes79438312c_utes
deuces94015512deuces
drupes94912652drupes
druses75517252druses
duces86327472_duces
educes94011952educes
eructs83610792eructs
fauces114916152fauces
graces94523492graces
grues65721962gru_es
grumes94415552grumes
luces75528432_luces
prices104524542prices
prudes94215442prudes
prunes83419062prunes
puces94924632_puces
races74943242_races
rices75536152_rices
rubes74928412_rubes
ruches114819582_ruches
rucks114422052_rucks
rues46044482_ru_es
rules55234252_rules
runes55530222_runes
ruses56136582_ruses
sauces84919502sauces
spruces113810502spruces
traces85329932traces
trices84826332trices
truce75118692truce_
truced95312052truced
trucks124711972trucks
trues54925322tru_es
uruses63616502uruses

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511102.64031269.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911102.79663909.5
 
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.