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

90 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
sabir7591699(None) 
saber75330241saber
sabin74924941sabin
sabirs85414621sabirs
abri65522212_abri
air38058392_a_ir
amir65129742_amir
astir55517092astir
babier103515562babier
caber95126832caber
cabin94820932cabin
fair76332522fa_ir
fakir125111492fakir
faqir17548642faqir
gambir11509752gambir
habit103027012habit
hair76330142ha_ir
jabiru15125502jabiru
kabar114815552kabar
kafir12488902kafir
labia75219002labia
labor75117312labor
lair45934152la_ir
mair66133762ma_ir
nabis76020572nabis
nadir61012972nadir
pair66031512pa_ir
rabic93817392rabic
rabid84520772rabid
sab56563202sab__
sabal75422482sabal
sabe66140572sab_e
sabed86526812sabed
sabers85224732sabers
sabes76437462sabes
sabine84020382sabine
sabins85521972sabins
sable74732162sable
sabot7931772sabot
sabra75317852sabra
sabre74821502sabre
sabs66643742sab_s
sadi55834642sadi_
sadis64930852sadis
safer84721812safer
sager65432052sager
sagier73717162sagier
sahib10314752sahib
said55742112sa_id
sail45447162sa_il
sain45551292sa_in
saker95132022saker
saki85628472saki_
sakis95323662sakis
salic73424712salic
sambar103914162sambar
sambur10469502sambur
saner54334322saner
santir6315242santir
sapid84720932sapid
sapor75119252sapor
sari45444042sari_
sarin55239252sarin
saris54544952saris
sasin54626572sasin
sati45539322sati_
satin55935212satin
satire63218002satire
satis55633672satis
satyr848482satyr
saver84831252saver
savin84625082savin
savior9710172savior
savor85417942savor
sawer85026212sawer
sayer84926552sayer
sayid95516722sayid
seabird1055362seabird
sir35746672s__ir
sober74822402sober
speir75315362speir
stair54719932stair
stir45723242s_tir
suber74924502suber
taber73825822taber
tabid84418252tabid
tabor75518392tabor
tapir75917062tapir
vair75624142va_ir
wair75830052wa_ir

Search took 5 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.186960704.3
2DLD Change Limit53800903.93613668.7
3Display Results90900.0631428.6
 (SQL Overall)178691904.18542698.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.