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

66 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
crevasse134309(None) 
crevassed1543201crevassed
crevasses1444141crevasses
crease85519572cre_a_se
creases94020962cre_ases
crevalle1346162crevalle
canvases13349523canvases
canvass12376873canvass_
canvassed15274043canvassed
canvasser14274263canvasser
canvasses14286043canvasses
cease75227653c_e_a_se
ceases84427073c_e_ases
chasse115114603c__hasse
cleanse9358723cle_anse
clevises1336903clevises
coevals1237873coevals_
crases85532313cr__ases
crass76328043cr__ass_
crasser94114343cr__asser
cravats1237403cravats_
creaks124315963cre_aks_
creams104715253cre_ams_
creased104315583cre_ased
creaser94415743cre_aser
creasier103210193cre_asier
creasy114612303cre_a_sy
create85126383cre_a_te
creates95225203cre_ates
creese84014333cre__ese
creeses93914623cre_eses
cremate113816183crema_te
cremates124216003cremates
crenate93317113crena_te
creolise1037863creolise
cress75022833cre__ss_
cresses94219813cre__sses
cresset93319943cre__sset
cressy11439113cre__ssy
crevalles1455723crevalles
crevassing1643533crevassing
crevice1436153crev_ice
crevices1536713crevices
crosse85216303cr__osse
grease75416233gre_a_se
greases84816713gre_ases
megasse10266243_megasse
prepaste12139083prepaste
pretaste10139523pretaste
prevalue1345073prevalue
previse123713793prev_ise
previses133814283previses
relapse947703_relapse
repass84114703_repass_
repassed11229273_repassed
repasses101810373_repasses
reraise7316313_reraise
retaste72313133_retaste
revalue1038153_revalue
reverse103913743_reverse
revise94019743_rev_ise
revises104220533_revises
rubasse934903_rubasse
urease64516993ure_a_se
ureases74416723ure_ases
wrasse9398773wr__asse

Search took 9 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.436409841.7
2DLD Change Limit146162667.67319048.9
3Display Results66660.0164125.0
 (SQL Overall)178691668.12521992.7
 
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.