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

73 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
crinite9513631crinite
crinites10612762crinites
trinity10310842trinity
acridity1446913acridity
aminity12310513aminity
arenite71017713arenite
aridity11510113aridity
binit76431583_binit_
binits85716673_binits
brinier93613473brinier
brinies93317913brinies
brining103216473brining
brinish1239963brinish
caitiff1547133caitiff
caninity1338063caninity
carinate103320243carinate
chining133316843chining
chints115117833chin_ts
chintz204212033chin_tz
clinic104312793clini_c
clinics11338743clinics
coining103920543coining
crania82418433crani_a
cranial92114683cranial
craniate10312563craniate
craning103620303craning
cranium11911103cranium
credit9315193credit_
credits1039973credits
crenate93317113crenate
crimine112413473crimine
crimini11258883crimini
criminy14268453criminy
cringe93515483crin_ge
cringed113312403cringed
cringer103514243cringer
cringes103215503cringes
cringing123311383cringing
cringle103010353cringle
crinkle13359413crinkle
crinkly16387523crinkly
crinoid1039943crinoid
crinoids1147363crinoids
crinum1039333crin_um
crinums1135863crinums
crisic103611843crisi_c
crisis83716343crisi_s
crista8311803cri_sta
crit65743713cr__it_
critic103616813criti_c
critics112811093critics
crits75527573cr__its
cronies9622503cronies
cronish12310863cronish
crudity1336043crudity
cyanite122710763cyanite
encrinite1146043encrinite
finite9316823_finite
finito9310303_finito
granita82111303granita
granite82017083granite
kainit10414483kainit_
kainite1149543kainite
kainits1137763kainits
pinite8321243_pinite
print74837463prin_t_
prints84320103prin_ts
privity15268313privity
trilith10310513trilith
trining82919213trining
triunity1145073triunity
uranite72515693uranite
urinate7315363urinate

Search took 7 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 Limit134027736.23321502.8
3Display Results73730.0332212.1
 (SQL Overall)178691736.67226782.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.