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

76 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
calypter154406(None) 
calypters1643591calypters
caliper11410962calip_er
calyptra1542962calyptra
clyster12317452c_lyster
accepter14144933accepter
adapter1036173_adapter
adepter1036113_adepter
adopter1036763_adopter
alerter72111513_alerter
alter54828503_al__ter
apter76120203_a__pter
balloter1078893balloter
baluster1037053baluster
cadaster1136903cadaster
calcite11413783calcite_
calcites12313003calcites
calender1138273calender
caliber1139733cal_iber
calipee11412913calip_ee
calipees1247413calipees
calipers1249443calip_ers
calker124917083cal__ker
caller85125483cal__ler
calliper1247513calliper
callower13159073callower
calmer105216933cal__mer
calotte9510563calotte_
calottes10610083calottes
caloyer1238143cal_oyer
calycate1537893calycate_
calyces14428803caly_ces
calycle14245833calycle_
calycles15295693calycles
calypso1443123calyp_so
calypsoes1642823calypsoes
calypsos1543113calypsos
calyptras1643133calyptras
calyxes19426233caly_xes
camper124722213ca_mp_er
campier133313273ca_mpier
canister101710853canister
canter85230113ca__nter
caper94831623ca__p_er
capper124421983ca__pper
captor104914603ca__ptor
carper104923633ca_rp_er
carter84932273ca__rter
caster85232573ca__ster
cater74840723ca___ter
catheter1338153catheter
cavorter1335783cavorter
chapter144213853c_hapter
clamper134012993clamp_er
clapper134011863c_lapper
clasper113811863clasp_er
clatter94014973c_latter
clayier1248323clay_ier
clipper133710323c_lipper
clouter93511693c_louter
cluster94013333c_luster
clutter94211663c_lutter
clypei1334163c_lyp_ei
clysters13227843c_lysters
colter84625093col__ter
copter109822013c__opter
cypher16306593c__ypher
falter94519053fal__ter
halter94420883hal__ter
kalyptra1751433kalyptra
maltster1035303maltster
palter84423263pal__ter
salter64325083sal__ter
saltpeter1153163saltpeter
saluter73512453sal_uter
scalper113912923scal_p_er

Search took 10 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.403443402.0
2DLD Change Limit146162769.23615825.2
3Display Results76760.0302533.3
 (SQL Overall)178691769.66918480.8
 
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.