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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
karat9683759(None) 
carat75048791carat
karate105320921karate
karats106420491karats
karst97228991karst
kart86750801kar_t
korat94934431korat
arak86929572_arak
arhat8327092_arhat
art38679142_ar_t
brat66055542_brat
carate84734002carate
carats85929022carats
caret75360562caret
cart66570342car_t
dart55857872dar_t
derat65044082derat
drat56247832_drat
farad95720672farad
fart76860562far_t
frat75648542_frat
grat55651282_grat
hart76865772har_t
jurat124829322jurat
kaas86531842ka_as
kabab134814442kabab
kabar114815552kabar
kaiak8310352kaiak
kaka76518682kaka_
kakas85117342kakas
kalam11315112kalam
kana85928532kana_
kanas95326912kanas
kapa106021292kapa_
kapas116021732kapas
kaput11717062kaput
karates115617472karates
karma113415002karma
karmas123013732karmas
karn86129412kar_n
karns96624142karns
karoo92519582karoo
karsts106012942karsts
karts97630112karts
kat77468292k__at
kata85626022kata_
katas95922092katas
kava115819702kava_
kavas125919952kavas
kayak1138362kayak
khat116730722k_hat
kora86431552kora_
korai97018522korai
koras95927112koras
korats105416062korats
kraal94511822kraal
kraft125721012kraft
krait94726772krait
kraut95221402kraut
kurta95113912kurta
kyat116025522k_yat
lariat6629042lariat
manat76039992manat
mara67444572mara_
maras75443292maras
mart66865982mar_t
para65242172para_
parae76335702parae
paras76143042paras
part65967462par_t
prat65952042_prat
qanat144426842qanat
rabat72832222rabat
rat37892742__rat
saran53730302saran
sprat76635972sprat
tarot55943932tarot
tart47566182tar_t
vara75530882vara_
varas86028192varas
wart77866082war_t

Search took 2 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.296603685.8
2DLD Change Limit53800811.50035866.7
3Display Results81810.0165062.5
 (SQL Overall)178691811.81298615.3
 
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.