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 “kakapos” 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
kakapos124367(None) 
kakapo1143851kakapo_
kakas85117342kaka__s
adapts9107813_adapts
agapes95212413_agapes
alamos8415003_alamos
apos65433823___apos
ataps76414833_atap_s
bayamos1434663bayamos
cacaos104616183caca_os
campos125217953ca_mpos
canapes111213083canapes
capos94826073__capos
catalos9414163catalos
cheapos14418513cheapos
dalapon1044893dalapon
dalapons1145433dalapons
galagos938143galagos
gazabos1944453gazabos
jalaps15299183jalap_s
kaas86531843ka_a__s
kababs14409773kaba_bs
kabakas12367403kabakas
kabalas133911063kabalas
kabars124513953kaba_rs
kabayas16316803kabayas
kaiaks937043kaia_ks
kaka76518683kaka___
kakis86116843kak__is
kalams12310603kala_ms
kaliphs1634293kaliphs
kalpacs15327133kalpacs
kalpaks12366163kalpaks
kalpas124112943ka_lpas
kamalas13339123kamalas
kanakas10327213kanakas
kanas95326913kana__s
kapas116021733__kapas
kaphs144911503__kaphs
kapok10448783__kapok
kapoks11347263__kapoks
kappas144410363ka_ppas
karates115617473karates
karats106420493kara_ts
karoos102415803ka_roos
karroos1139313karroos
katas95922093kata__s
kavas125919953kava__s
kavass13517303kava_ss
kayaks1236333kaya_ks
kayos127714703__kayos
kazoos19259113ka_zoos
khaphs18394323k_haphs
knaps115511173k_nap_s
lavabos1235453lavabos
macacos1338083macacos
makars124612633maka_rs
makos116518363mak__os
mikados1444683mikados
okapis1235393_okapis
palapas11311493palapas
parados103816053parados
paramos113213513paramos
paraphs1439313paraphs
rabatos93010903rabatos
sarapes94617743sarapes
takahes1436173takahes
takas95520683taka__s
tapalos938813tapalos
uakaris1146633uakaris
wakames1635283wakames
watapes12228383watapes
wataps11248683watap_s

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.1401276364.3
2DLD Change Limit134027735.94022563.5
3Display Results73730.0302433.3
 (SQL Overall)178691736.11029245.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.